package com.lyn.mango;

import org.jfaster.mango.annotation.DB;
import org.jfaster.mango.annotation.SQL;

@DB
public interface MangoDao {
    // 插入数据
    @SQL("insert into tbl_data_hyydflb(guid, nian, yue, tjm, dwdm) values(:1, :2, :3, :4, :5)")
    public void add(String guid, int nian, int yue, String tjm, String dwdm);

    // 根据name取num的总和
    @SQL("select sum(yue) from tbl_data_hyydflb where dwdm=:1")
    public int getTotalYue(String dwdm);

}
